package com.yj.service;

import com.yj.entity.Region;
import com.yj.vo.JsonResult;

import org.springframework.web.bind.annotation.RequestParam;

import com.baomidou.mybatisplus.extension.service.IService;

/**
 * <p>
 *  服务类
 * </p>
 *
 * @author yj
 * @since 2020-08-24
 */
public interface IRegionService extends IService<Region> {

	//省份集合
	public JsonResult AllProvince();
	
	//区集合
	public JsonResult Allcity(String province);
	
	//热门城市
	//SELECT r.city from region r WHERE r.did in (SELECT DISTINCT h.did from houses h where h.did in (select hid from details GROUP BY hid ORDER BY COUNT(hid) DESC))
	public JsonResult Houcity();
	
	
	//删除城市
	public JsonResult delRegion(int did);
	
	//添加城市
	public JsonResult addRegion(Region region);
	
	//更新城市
	public JsonResult update(Region region);
	
	//分页查询地区
	//页码
	public JsonResult pages();
		
	//每页数据
	public JsonResult page( int pageNum);
	
	
	
	
	
}
